﻿-- =============================================
-- Script Template
-- =============================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Sys_ActivityTypeMaster]'
GO

	SET IDENTITY_INSERT [Sys_ActivityTypeMaster] ON
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'CRT', N'CREATE', N'For Creting new data but cannot update existing data or delete existing data', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'RTV', N'RETRIEVE', N'For Retrieving/Viewing existing, read only purpose', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'UPD', N'UPDATE', N'For Updating existing data but cannot delete existing data and also cannot create new data', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	INSERT [Sys_ActivityTypeMaster] ([ActivityTypeKey], [ActivityTypeCode], [ActivityTypeName], [ActivityTypeDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'DEL', N'DELETE', N'For Deleting existing data but cannot update existing data and also cannot crete any new data', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
	SET IDENTITY_INSERT [Sys_ActivityTypeMaster] OFF